总账核销

概述

核销原理

未核销报表

自动核销

 (CASE WHEN fa.AD_Table_ID =  318 /* C_Invoice */ 
THEN (SELECT (CASE WHEN i.DocStatus IN ('VO','RE') AND i.Reversal_ID > 0 
                            THEN 'Auto C_Invoice Reversed:' || least(i.C_Invoice_ID, i.Reversal_ID)
                             WHEN i.DocStatus = 'VO'
                             THEN 'Auto C_Invoice Voided:' || i.C_Invoice_ID
                             ELSE 'Auto C_Invoice:' || fa.Record_ID END)
              FROM C_Invoice i
              WHERE i.C_Invoice_ID=fa.Record_ID)  
 WHEN fa.AD_Table_ID = 735 /* C_AllocationHdr */  
 THEN (SELECT 'Auto C_Invoice:' || al.C_Invoice_ID FROM C_AllocationLine al 
 WHERE al.C_AllocationHdr_ID = fa.Record_ID 
 AND al.C_AllocationLine_ID = fa.Line_ID ) END)

手动核销

取消核销